﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ESOL.Common.Entity;
using Suzsoft.Smart.Data;

namespace ESOL.Business
{
    public class TestConnection
    {
        public static SecUserEntity GetUserByCode(string userCode)
        {
            string sql = "SELECT * FROM SEC_USER WHERE UPPER(USER_ACCOUNT) = '" + userCode + "'";
            List<SecUserEntity> list = DataAccess.Select<SecUserEntity>(sql);
            if (list != null && list.Count > 0)
            {
                return list[0];
            }
            return null;
        }
    }
}
